This document contains changes and additions to the 1–2–3® for Macintosh® Release 1.0 documentation. It includes the following topics: Menu Access Keys, Guided Tour, User's Guide, Learning Guide, @Functions and Macros Guide, and the Guide for Experienced Spreadsheet Users.
MENU ACCESS KEYS AND INTERNATIONAL KEYBOARDS
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
By default, 1–2–3 for Macintosh uses the slash (/) key to display the 1–2–3 Classic menu and Option-/ to activate keyboard access to the pull-down menus. If you're using an international keyboard, you may prefer to use the less-than (<) key and Option-< instead. For information on changing menu access keys, see “Setting Keys for Menu Selection” on page 326 of the 1–2–3 for Macintosh User's Guide or “Setting Keyboard Preferences” in 1–2–3 Help.
GUIDED TOUR
~~~~~~~~~~
• The MacroMind Director® Player that runs the Guided Tour is incompatible with the Møire 3.22 screen saver. If the Møire 3.22 screen saver is installed on your Macintosh, you must disable it before you run the Tour.
• When you run the Guided Tour on a color monitor with at least 1900K of memory available, the Tour changes the Monitors setting to Colors even if you had it set to Grays. To reset your monitor to Grays after you take the Tour, choose Control Panel(s) from the Apple menu and change the Monitors setting.
• NOTE for Users with Gray-scale Monitors: The Tour looks best on a gray-scale monitor if you set the Control Panel Monitors setting to Grays 256 before you start the Tour.
START HERE
~~~~~~~~~~~
• On page 19, in “Showing Connecting Lines in Stacked Bar Graphs,” sentence 1 should read:
You can show connecting lines between bars in stacked 2-D bar graphs.
Step 2 should read:
Choose Options Bar Type from the Graph menu.
USER'S GUIDE
~~~~~~~~~~~
• On page 15, in “Saving a New Document,” step 3, sentence 1 should read:
Type a document name of up to 31 characters in the “Save as” box.
• On page 17, in “Getting Help,” insert this sentence at the end of the first bulleted item in step 1:
On a small screen, such as on a Macintosh SE, choose 1–2–3 Help from the Apple menu.
• On page 20, in “Opening Existing Documents,” insert this paragraph after the last paragraph:
1–2–3 for Macintosh doesn't directly open documents stored on 400K disks. To open a document stored on a 400K disk, copy the document to your hard disk and then open the document.
• On page 35, in “Entering Text,” step 2, sentence 1 should read:
Type an entry of up to 512 characters.
• On page 37, in “Annotating a Numeric Entry,” delete the Note.
• On page 68, in “Moving Entries,” the last paragraph should read:
When you use the Move Cells command, 1–2–3 also moves the text styles, formats, and protection status associated with the cell contents.
• On page 78, in “Sorting with More than Three Keys,” step 1 should read:
Follow steps 1 through 7 in the procedure above to define the first three Sort keys.
• On page 79, in paragraph 2, delete sentence 1. Sentence 2 should read:
You can use any fonts installed in your System to enhance the appearance of data in your worksheet.
• On page 81, in “Formatting Cells,” insert this tip in the margin next to “To format cells:”:
Don't select entire rows or columns to format; formatting many blank cells increases the size of the document unnecessarily. To format an entire document, use a global sheet setting.
• On page 84, in “Changing Font, Size, and Emphasis,” delete sentences 2 and 3 from paragraph 2.
• On page 91, in “Hiding Columns and Sheets,” the picture titles should read:
Before Hiding Columns
After Hiding Columns
• On page 99, in “Naming Ranges Using Adjacent Text,” paragraph 2, sentences 2 and 3 should read:
For example, Don's Photography-Sales is too long and contains characters you should avoid using. Don_Photo_Sales is a better name because it's fewer than fifteen characters and contains only letters and underscores.
• On page 105, in “Using Range Name Notes,” the second bulleted item in the step 3 at the top of the page should read:
To edit an existing note, edit the text as you would in any Macintosh program. You can make words wrap to a new line by inserting spaces or Option-spaces. Keep in mind that spaces also appear in a range name table if you create a table that includes the note. Pressing Return or Enter closes the dialog box.
• On page 111, in “Using One-Way Tables,” in the picture at the top of the page, cell D1 should display the formula +B1/12.
• On page 133, in “Unprotecting Sheets,” step 2 should read:
Turn off “Protect sheet.”
• On page 143, in “Bringing Pictures into 1–2–3,” delete step 3, and change step 4 to step 3.
• On page 153, in “Changing Interior Patterns,” sentence 2 in the last paragraph should read:
The interior gradually changes from the foreground color to black, either from top to bottom or bottom to top.
• On page 201, in “Selecting and Adding Graph Parts,” insert this tip in the margin next to paragraph 2:
To select an entire data set, click any part of it; to select an individual data point marker or individual bar, double-click it.
• On page 209, in “Adding and Reassigning Data Sets,” insert this tip in the margin next to “To add or reassign a data set:”:
You can also copy a new data set or sets, select the graph, then choose Paste from the Edit menu. Include only the data, not the label text.
• On page 215, in “Creating Scatter (XY) Graphs,” step 5 should read:
To assign the dependent variables, turn on “Left column for x-axis labels” or “Top row for legend.”
• On page 220, in “Setting Up a Database Table,” paragraph 1, sentence 3 should read:
The number of smaller tables you can put in one worksheet is limited only by memory.
• On page 222, in “Creating a Form,” insert this tip in the margin next to paragraph 2:
If you're connected to an external FoxBASE® table, you can use only one form at a time. For details, see page 254.
• On page 241, in “Finding Matching Records,” paragraph 2, sentence 2 should read:
Before you can use the Find command to find records in a table, you must set up input and criteria ranges as described on page 236.
• On page 241, in “Finding Matching Records,” insert this Note after step 4:
NOTE: Many menu commands are dimmed while you're finding records, and you can apply formats and fonts only by using the Range Format and Style Font commands, not directly from the Range and Style menus. To make commands available again, end the Find operation by pressing Enter or Escape.
• On page 242, in “Finding Matching Records,” in the table of keystrokes, the final table entry in the Press.. column should read:
Enter or Escape
• On page 247, in “Calculating with Matching Records,” paragraph 1, the last sentence should read:
A summary field uses a formula to calculate a total for a group of records that have the same value in one field.
• On page 248, in “Calculating with Matching Records,” step 1 should read:
Enter one or both of the following in the field name row of the output range:
• On page 251, in “Extracting Records from Multiple Tables,” delete paragraph 1 and the second picture. Replace them with this Note:
NOTE: If you want to combine the field contents of each table with the field contents of ALL other tables, you can leave the criteria range blank. For example, you might want to create a list of every possible variation on every part number in an inventory. But keep in mind that you should do this only with small database tables. For example, for two tables each containing ten records, your output range will contain 100 records.
• On page 254, in “Connecting to FoxBASE Tables,” insert this paragraph after paragraph 1:
You can use only one database form at a time when you're connected to a FoxBASE table. While the “Allow updates” checkbox is on in the form, and the form is open, you can't create a new form or use the Query command in the Data menu. In addition, 1–2–3 doesn't recognize the FoxBASE memo and picture data types.
• On page 255, in “Connecting to FoxBASE Tables,” the picture at the bottom of the page shows the file EMPFILE with a .DBF extension. The file that actually comes with 1–2–3 doesn't have this extension. The file is also incorrectly shown this way on pages 256, 264,and 271.
• On page 257, in “Connecting to DAL Tables,” insert this paragraph after paragraph 1:
When you connect to DAL tables, you can't create or delete tables in the database. In addition, if you're using DAL to connect to a Sybase® database, the Sybase software doesn't let you update records.
• On page 260, in “Listing Fields,” insert this Note after paragraph 1:
NOTE: If you already know the field names in the external table you want to use, you don't have to list fields.
• On page 262, in “Performing a Query,” insert this paragraph after paragraph 1:
When 1–2–3 extracts the value “datetime” (a Sybase data type) from a Sybase database, Sybase provides only an approximate time value. For this reason, you may not get a match if you use an extracted “datetime” as a criterion in a new query. If you want to use dates or times as criteria, enter them directly.
• On page 266, in “Creating and Deleting FoxBASE Tables,” delete this sentence in paragraph 5:
You'll need to transpose the field names first, as described on page 262.
• On page 269, in “Sending Commands to a DBMS,” insert this sentence after step 2:
Once you've connected, the Connect button changes to Send.
• On page 271, in “Disconnecting from External Tables,” insert this Caution after paragraph 1:
CAUTION: If you're using a modem with the DAL driver, disconnect from the host by saving your changes and closing the worksheet document instead of following the procedure below. Depending on how your modem is set up, the procedure below may disconnect you from the external database table, but not from the host itself.
• On page 283, in “Refreshing Links,” paragraph 2 should read:
To refresh the links in all open documents, choose Administration>Update Links from the File menu.
• On page 297, in “Arranging Windows,” delete the tip in the margin.
• On page 359, in “Data Menu,” the description of the Translate command should read:
Selects a character set for 1–2–3 to use with a specific database when extracting or modifying data.
• On page 370, in “Printing in Color,” insert these four paragraphs after paragraph 1:
1–2–3 sends color information to a printer in two different ways, depending on the type of printer. Options for most color and grayscale printers appear when you choose Print from the File menu. For example, if you're using a LaserWriter® and want to print colors or grays, click Color/Grayscale in the Print dialog box.
Some printers use 8 specific colors for printing. For example, the ImageWriter® II prints with an 8-color ribbon. You can print with these eight colors even when you're working in black and white, because you can choose the colors from a menu of color names. To use 8-color printing in 1–2–3, choose Print from the File menu and turn on “Print in color” in the dialog box that appears. If the dialog box contains additional options specific to your printer, you must also set those.
Whatever printer you use determines the colors or gray scales used. The printed quality of certain interior patterns may not be the same as the on-screen display.
You can print graphs using hatch patterns instead of colors or grays. To print using hatch patterns, choose Print from the File menu, turn on any setting specific to your printer for black-and-white printing, and turn off “Print in color.” For example, if you're using a LaserWriter, click Black & White and turn off “Print in color.”
LEARNING GUIDE
~~~~~~~~~~~~~
• On page 16, in “Entering New Values,” step 6 should read:
Type 5000 and press Return.
• On page 32, in “Changing the Appearance of Text,” insert this paragraph between paragraphs 1 and 2 of step 3:
If you're using a LaserWriter or LaserWriter Plus, printing the page may take a few minutes because the printer handles the Chicago font differently from a laser font. You may want to use a laser font like Times instead.
• On page 36, in “Printing a Sheet,” insert this paragraph after the picture in step 2:
The page you print may look slightly different from the one shown above. For example, it may not have column letters, row numbers, or grid lines. See “Hiding or Showing Elements in Print” on page 305 of the User's Guide or “Printing Selected Elements” in 1–2–3 Help for information on turning these elements on or off for printing.
• On page 42, throughout Lesson 6, graphs you create may appear larger than shown in the pictures. To work with them, scroll or zoom the worksheet window.
• On page 44, in “Changing a Graph Title,” in “To change the graph title's frame,” step 3 should read:
Choose None from the Shadow pop-up menu.
• On page 46, in “Moving and Resizing a Graph,” in “To move the graph,” step 2 should read:
Drag the graph to the vertical scroll bar and then down until you see the top row of the sheet.
• On page 50, in “Changing a Graph's Appearance,” step 1 should read:
Choose Show Style Palette from the Style menu.
• On page 57, in “Changing a Text Block,” the second to last sentence should read:
If the Style palette isn't open, choose Show Style Palette from the Style menu.
• On page 79, in “Printing Selected Worksheet Areas,” in “To select sheet A's heading and operating income for printing,” substitute Command-drag for Command-click in paragraphs 1 through 3 of step 2.
• On page 80, in “Printing Selected Worksheet Areas,” in “To select all of sheets B and C for printing,” substitute Command-drag for Command-click in step 2 and in the paragraph under step 4.
• On page 80, in “Printing Selected Worksheet Areas,” in “To print the selected ranges,” step 1 should read:
Choose Print from the File menu.
Insert a new step 2, which should read:
2. Turn on “Print selection.”
The existing step 2 becomes step 3.
• On page 85, in “Linking Documents,” in “To enter the second formula,” step 7 should read:
Click Confirm and then click the down scroll arrow.
• On page 99, the picture should be the same as the picture shown on page 97.
• On page 111, the step 3 at the bottom of the page should read:
Click Don't Save.
@FUNCTIONS AND MACROS GUIDE
~~~~~~~~~~~~~~~~~~~~~~~~~~
• On page 27, in the table “Attribute Arguments for @CELL,” the entry in the Result column for the height attribute should read:
the row height
• On page 117, insert this text after the first bulleted item:
Use either a semicolon or a comma; if you try to use a period as a place holder, 1–2–3 assumes you are indicating a range and will be unable to perform the macro command. To change the preferred argument separator, use the User Setup>International command in the Tools menu.
• On page 220, in “{Dispatch},” insert this text at the end of paragraph 4:
In the example below, if you want the {Let} command to put the text string Negative, Zero, or Positive into Switch, enclose these arguments in quotes. Otherwise, 1–2–3 assumes that each of these arguments is the name of a cell that contains a text string.
• On page 353, in the table “Info Components,” the entry in the Type column for Print-Stationery-Pages should read:
“none”, “all”, “first”, “last”, “all-but-first”
The entry in the Type column for Print-Stationery-Print should read:
“print-over”, “print-under”
• On page 358, the entry in the Type column for Worksheet-Format-Display-Zeros should read:
“blank”, “show”, “label”
The entry in the Definition column for Worksheet-Format-Display-Zeros should read:
Whether to display zeros in the active sheet as blanks, values, or text.
• On page 361, in the table “Macro Commands Specific to 1–2–3 Release 2 and Release 3,” the entry in the Description column for {Graph} should read:
Displays the currently selected graph, and scrolls the sheet to make this graph visible; if no graph is selected, draws the unnamed graph on the sheet and scrolls to display it.
The entry in the Description column for {Graphoff} should read:
Has no effect in 1–2–3 for Macintosh.
GUIDE FOR EXPERIENCED SPREADSHEET USERS
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
• On page 42, in “Graphs,” insert this paragraph after paragraph 1:
PC versions of 1–2–3 draw the first data point in a pie graph at the 3 o’clock position and draw the rest of the data points counterclockwise.
• On page 59, in “/Graph Commands,” insert this paragraph after paragraph 2:
Using the /Graph Options Color and /Graph Options B&W commands in the 1–2–3 Classic does not affect the appearance of graphs in 1–2–3 for Macintosh. However, if you save the file and re-open it in Release 2 or Release 3, the graph appears with the color settings you applied with these commands.
• On page 62, in “/Worksheet Commands,” paragraph 3 should read:
In addition, the /Worksheet Global Default Printer and /Worksheet Global Default Status commands have no effect in 1–2–3 for Macintosh.
• On page 63, in “Using Macros Created in Releases 2 and 3,” insert this Note after paragraph 2:
NOTE: If you want to share files that contain macros with a 1–2–3 for Windows Release 1.0 or 1.1 user, use 1–2–3 Classic (slash key) macros. 1–2–3 for Macintosh can't interpret all macros from 1–2–3 for Windows. For example, macros that depend on 1–2–3 for Windows pull-down menu command names (macros beginning with {ALT}) are not usually compatible.
• On page 66, in the table “Release 2 and Release 3 Macro Commands that Work Differently,” the description of the {Form} command should read:
If a Release 2 or Release 3 macro that uses the {Form} command tells you to press Insert, and you're using the Apple Extended keyboard, press Shift-Help.
• On page 67, in “Macros that Depend on Window Size,” replace sentences 2 and 3 in paragraph 2 with the following sentences:
For example, if your Macintosh has a 13" screen and the font used is Geneva 10, you can add the command {Window-Adjust ;;587}. If your Macintosh has a 9" screen, you can use {Set "worksheet-font-size";8}, {Set "worksheet-font";Geneva}, and {Window-Adjust ;;511;289}. To make the window the proper size, you must also click the console's close box and then click the worksheet window's zoom box.
• On page 70, in “Macros that Graph,” insert this paragraph after paragraph 1:
You can’t use the {Graphon} macro command to refer to a file other than the active file. To refer to a graph in an inactive file, use the /GNU macro command instead and make sure the referenced file name contains a maximum of eight characters plus a .WK3 file extension.
• On page 98, in “Saving a 1–2–3 Document for Use in Excel,” insert this sentence at the end of paragraph 1:
You can save a document in Excel 2.2 format only. An Excel user can open this document in either Excel 2.2 or Excel 3.0.
• On page 99, in “Saving a 1–2–3 Document for Use in Excel,” step 4 should read:
Choose Excel 2.2 Sheet from the “File type” pop up.
• On page 100, in “Cells and Ranges,” insert these paragraphs after paragraph 1:
When you open an Excel document in 1–2–3, you see cell contents aligned left, center, or right as they were in Excel. When you save a document for use in Excel, however, 1–2–3 translates all text left-aligned and all numbers right-aligned.
If a cell in an Excel document contains text aligned as "Fill," 1–2–3 precedes the text with a backslash (\). This tells 1–2–3 to fill the cells with repeating characters. If a number or formula is aligned as "Fill," 1–2–3 translates it right-aligned.
• On page 101, in “Formulas,” sentence 2 should read:
The largest number 1–2–3 can calculate with is 1.2E4932, although it can only display numbers up to 9.99E99. The largest number Excel can calculate with is 1.789E305; when you open an Excel document in 1–2–3, Excel numbers higher than 9.99E99 appear as asterisks, no matter how wide you make the column.
• On page 101, “Operators, Parentheses, and Order of Precedence,” sentence 1 should read:
1–2–3 and Excel use almost identical arithmetic and logical (comparison) operators, except for the range operator (colon) and the intersection operator (space), which 1–2–3 translates as @XL_RANGE($range1,$range2) and @XL_ISECT($range1,$range2).
• On page 101, in “Operators, Parentheses, and Order of Precedence,” add this Note after paragraph 2:
NOTE: You may not see the differing results until you edit the formula, which forces the formula to recalculate. Note that choosing Calculate from the Function pop up doesn’t recalculate the formula.
• On page 102, in “Functions,” insert these paragraphs after paragraph 1:
In cases where there is no Excel equivalent for a 1–2–3 @function, or when a 1–2–3 function argument refers to a multi-sheet range, 1–2–3 translates the function as =“@function-name(arguments).” There are no Excel equivalents for the add-in @functions @ISAFF and @ISAPP.
When you open a 1–2–3 document in Excel, all the 1–2–3 database @functions, the @INDEX function (with a single-sheet range argument), and the @@ function result in #VALUE!. To see the correct result in Excel, click the cell containing #VALUE!, click the formula bar, and press Return.
• On page 102, in “Arithmetic Functions,” replace sentence 3 in paragraph 1 with these sentences:
Furthermore, there are no 1–2–3 equivalents for the INT, FACT, LOG, PRODUCT, and SIGN functions; there is no Excel equivalent for the 1–2–3 @SUMPRODUCT function.
• On page 102, the sentence preceding the table should read:
For example, if the equation MOD(n,d) is defined as n-(d*INT(n/d)), then MOD(n,d) produces the following results in Excel and 1–2–3:
• On page 102, in “Database Functions,” replace the last sentence with these sentences:
There are no 1–2–3 equivalents for the Excel DPRODUCT and DCOUNT functions. There are no Excel equivalents for the 1–2–3 @DGET and @DQUERY functions.
When you open a 1–2–3 document in Excel, all the 1–2–3 database @functions result in #VALUE!. To see the correct result in Excel, click the cell containing #VALUE!, click the formula bar, and press Return. When you do this, the 1–2–3 @DSTDS and @DVARS functions may result in DIV/O! because 1–2–3 and Excel sometimes evaluate these functions differently.
• On page 102, in “Date and Time Functions,” insert this sentence at the end of paragraph 1:
1–2–3 translates the Excel DATEVALUE function to @DATEVALUE, but the formula results in ERR in 1–2–3 if the cell is formatted as mm/dd/yy hh:mm and the argument is in the form (“11/4/91 11:40”).
• On page 103, in “Date and Time Functions,” insert this sentence after paragraph 1:
There are no Excel equivalents for the 1–2–3 functions @D360 and @TODAY.
• On page 103, in “Financial Functions,” the paragraph should read:
1–2–3 translates the Excel functions DDB, SLN, and SYD. It also translates the Excel NPV function if only the first two arguments are present. 1–2–3 translates the FV, IRR, PMT, and PV functions in both directions, but the order of the arguments in 1–2–3 differs from that in Excel. There are no 1–2–3 equivalents for the Excel IPMT, MIRR, NPER, PPMT, and RATE functions. There are no Excel equivalents for the 1–2–3 @CTERM, @RATE, @TERM, and @VDB functions.
• On page 103, insert this section between “Financial Functions” and “Logical Functions”:
Information Functions
There are no 1–2–3 equivalents for the Excel ADDRESS, AREAS, COLUMN, ISBLANK, ISLOGICAL, ISNONTEXT, OFFSET, ROW, and TYPE functions. 1–2–3 translates the N and T functions, but they result in ERR if the arguments don’t refer to cells or ranges. If a translated N function refers to a single cell and evaluates to ERR in 1–2–3, double-click the cell and press Enter to have 1–2–3 recalculate the result. Note that the S function in 1–2–3 is the equivalent of the T function in Excel.
• On page 103, in “Logical Functions,” insert this sentence at the end of the first paragraph:
When you save a 1–2–3 document for use in Excel, 1–2–3 translates the 1–2–3 operators #AND#, #NOT#, and #OR# to the Excel logical functions AND, NOT, and OR.
Insert this sentence after the second paragraph:
When the ISNUMBER function argument refers to a blank cell or an undefined range name, 1–2–3 evaluates it as True; Excel evaluates the same formula as False.
• On page 103, in “Lookup Functions,” insert this paragraph:
1–2–3 doesn’t translate the 1–2–3 Special functions @CELLPOINTER, @COORD, @INDEX (with a multi-sheet range argument), or @SHEETS. When you save a document for use in Excel, 1–2–3 adds one to the third argument of the @HLOOKUP and @VLOOKUP functions; it adds one to the first argument of @CHOOSE; and it adds one to both the second and third arguments of @INDEX. 1–2–3 does this because Excel starts numbering these arguments at one, while 1–2–3 starts at zero.
• On page 103, insert this section between “Matrix Functions” and “Text Functions:”
Statistical Functions
There are no 1–2–3 equivalents for the Excel GROWTH, LINEST, LOGEST, MEDIAN, PRODUCT, and TREND functions. The Excel COUNTA function is equivalent to the @COUNT function in 1–2–3; both functions count non-blank cells in a range. There is, however, no 1–2–3 equivalent of the COUNT function in Excel, which counts cells containing numeric values.
• On page 103, in “Text Functions,” the last sentence should read:
There are no 1–2–3 equivalents for the Excel functions TEXT, SUBSTITUTE, DOLLAR, and SEARCH. When you save a document for use in Excel, 1–2–3 adds one to the second argument of @MID and @REPLACE. The CHAR function produces different results in Excel and 1–2–3 if the argument number is greater than 127. The CLEAN function may also produce different results: in 1–2–3, CLEAN removes control characters from a string, while in Excel it removes non-printing characters.
• On page 104, in “Trigonometric Functions,” insert this sentence after paragraph 1:
There are no 1–2–3 equivalents for the ACOSH, ATANH, COSH, SINH, and TANH functions.
• On page 104, in “Linked Documents,” insert this paragraph:
If you translate the referenced document and the linked formula still evaluates to ERR, do the following: (1) Edit the reference so that it correctly describes the location of the document on the Macintosh hard disk or file server; and (2) Set the default folder to the folder where the referenced document is located, using the User Setup>Preferences command in the Tools menu. For more information about using file references in linking formulas, see Chapter 20 of the User’s Guide.
• On page 104, in “Named References,” insert this paragraph after the first paragraph:
1–2–3 doesn't translate Excel range names that are defined by relative references or by multiple ranges. However, 1–2–3 does translate Excel range names that are defined by absolute references. In addition, if you open an Excel document containing a formula that refers to a named range defined by a relative reference, 1–2–3 substitutes the address for the range name in the formula.
• On page 104, insert this section between “Page Breaks” and “Rows and Columns”:
Printing
If the print area defined with the Set Print Area command in Excel is a single range (not multiple ranges), 1–2–3 translates it as a range named Print_Area. For more information on setting print options in 1–2–3, see Chapter 22 of the User’s Guide. 1–2–3 doesn’t translate Page Setup or Print Options settings in either direction; these settings include headers, footers, and margins, as well as display of grid lines, row numbers, and column letters.
• On page 104, in “Rows and Columns,” insert these paragraphs after paragraph 1:
When you open an Excel document in 1–2–3, 1–2–3 translates Excel column widths and row heights to their closest 1–2–3 equivalents, except for the following: it changes an Excel row height of zero to a 1–2–3 height of one pixel (.014"), and it sets a column whose width is zero to “hidden.” 1–2–3 translates an Excel row height only if the row contains data; otherwise, it sets the row height to the 1–2–3 default.
When you save a document for an Excel user, 1–2–3 translates column widths to the Excel default (10 characters).
• On page 105, in “Settings,” insert this sentence at the end of the paragraph:
1–2–3 preserves the Excel protection of cell contents, but not of windows or objects. When you save a document for use in Excel, 1–2–3 doesn’t preserve protection, display, or calculation settings.
• On page 109, in “Opening an Excel Macro Sheet in 1–2–3,” the translated macro on the right side of the picture should read:
• On page 112, the information in row 12 of the picture should read:
A11 This Excel function has no equivalent in 1–2–3, so it can't be translated.
The picture should also include row 13 with the following information:
Completed FINAL PASS.
• On page 114, in “Log Messages,” the explanation of the second to last log message should read:
This Excel macro function (or one or more of its arguments) didn't have a 1–2–3 equivalent, so 1–2–3 didn’t translate it.
• On page 115, in “Log Messages,” add this message and its explanation:
This Excel macro function specified a text file to act on. In 1–2–3, only one text file can be open at once, so the translated 1–2–3 macro command acts on the open text file.
This Excel macro function specified the text file, by number, that it acted on. In 1–2–3, only one text file can be open at once; when you open a text file, 1–2–3 automatically closes any text file that was already open. The translated 1–2–3 macro command acts on the open text file. Be sure this is the file you want this macro command to act on.
• On page 122, in the table “LMBCS Codes and Characters,” when you see a single letter, for example Option-U, use a lowercase letter. Use an uppercase letter only when the combination includes Shift, for example, Option-Shift-C.
